Thank you for you help!
I have followed your suggestion, I created a function that check for the available seats right before inserting the new ones. It works great!
Do you know if this is way done by hotels and airlines? Are they any other ways to do it?
Thank you again! 🙂