In your first response you said, "Yes. There is nothing to prevent two people from getting the same key value." Do you have any support for that claim?
>You didn't get it. The problem is not with the UPDATE, but the original INSERT. There is nothing to stop two people from inserting the same record.
Yes there is: it would cause a primary key violation of the KeyCtr table.