select and update at the same time to be crisp.. i dont think so wat i would do is this.. 1 find the best job and set a reserve timestamp ( select 2. gve the user 3 minutes to confirm or the job is again to the open