A good RDBMS will have atomicity with its transactions. The issue here is your table design is too limited for your job queue to work. Change your job_done boolean into a multi-status tinyint value of ...
Our team is proposing some changes to the job scheduler policy for Medicinebow based on feedback from our users and we plan to implement this during our maintenance window starting January 6th, 2025.