Specifically you also want SELECT ... FOR UPDATE SKIP LOCKED;