I just meant a regular update (which might impact 0 rows) and then insert(not exists) like you are doing already.
--transaction still ways. Should manual locking used or is there bettermethod.I don't follow what you mean.