Pessimistic Locking Patterns

Implement explicit row-level locks for high-contention resources where collisions are expected.