https://gpttutorpro.com/how-to-avoid-and-resolve-deadlocks-in-transactions/