race conditions, row-level locks, and why your isolation level matters.