Need to insert a row if it doesn't exist, or update it if it does, atomically.

Without concurrency control, two users reading the same record and updating it concurrently cause a lost update — the second write silently overwrites the first. This is invisible without explicit locking.