How to split out this multi table transaction CRUD operations?

I currently have a process that is doing the following: START TRANSACTION DELETE FROM Foo WHERE id=123; #id is PK DELETE FROM Bar WHERE foo_id=123; #multirow delete INSERT INTO FooBar the row we deleted application level logic END TRANSACTION I want to find a way to not dot it all at one blocking transaction. I was thinking to add cols to indicate if a row has been deleted and run another process for cleanup but I was wondering if there is another way that perhaps MySQL supports