maybe skip this whole bit by changing the final `SELECT` statement in `obtainNextUnlockedJob` to

```sql
UPDATE job_snapshots
  SET processed = NOW()
  WHERE id IN (SELECT * FROM candidate_job where locked)
  RETURNING *
```

rather than

```sql
SELECT * FROM candidate_job where locked
```