多次插入后更新特定记录 - 可能使用last_insert_id（）

I have a multiple insert (4 records) using a for loop. I then want to run an update query on the record that was inserted where pathway_allowed = 'y' (only one of the 4 would have this value). I guess last_insert_id() would be useful here but not sure how to use this to update that record inserted with the following:I have a multiple insert (4 records) using a fo