How do you handle database locks and transaction isolation levels in a highly concurrent environment?