2 INSERT INTO verification_in_progress
3 (id, topic_id
, callback
, claimant
, claim_expires
)
4 SELECT id, topic_id
, callback
, $
(claimant
) AS claimant
, now() + $
(claimTimeoutSeconds
)::text::interval AS claim_expires
6 WHERE id = $
(verificationId
)
7 FOR UPDATE OF verification SKIP LOCKED
8 ON CONFLICT (topic_id
, callback
) DO UPDATE
10 claimant
= $
(claimant
),
12 claim_expires
= now() + $
(claimTimeoutSeconds
)::text::interval