Comment by AdamJacobMuller

update row set taken=true,taken_by=my_id,taken_at=now() where taken is false;