Two Guests, One Room, Zero Availability — A Concurrency Problem That Breaks Hotel Bookings

You’re building a room booking system. 10 rooms, multiple users booking simultaneously. What could go wrong?