Hacker News Reader

You can do something like UPDATE row SET timeout = NOW() WHERE NOW() - taskTimeout > row.timestamp. You're not stuck with comparing bools.

update tasks set taken_timestamp = now() where task_id = ? and taken_timestamp is null

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