Whenever you're ready, walk me through how you'd approach this.
Explain how you use ACID properties to handle concurrency in a database.