PHP and MySql item management with batch numbers

I have two different BRUSH with different batch numbers in the mysql database. I want a way I can sell the products by batches so that when the first batch finishes the next same product start selling. The issue now is that when the quantity of the first product is left with 2 and the client demands for 3 products, the system should be able to sell all the product in the first batch and get the difference from the next batch of the same product. USING PHP

  table_id      product_name     batch_number        expiry_date      quantity
---------------------------------------------------------------------------------
      1             BRUSH        Z12W3               2021-06-30           2
      2             BRUSH        YTYBB               2021-07-01           20
      3             SOAP         123                 2024-08-09           30

source https://stackoverflow.com/questions/67853093/php-and-mysql-item-management-with-batch-numbers