Your database usage should not involve application-focused locks, MVCC will restart your transaction if needed to resolve concurrency.