I have an SQL query to select and update rows in a table.

I do this in batches of 300 rows (select 300 , update the selected 300 , select new 300 and update the newly selected and so on..)

I run this query in 2 different notebooks concurrently to speed up my processing

Can someone tell how to prevent the same row from the table getting selected in the sql query ?