1 -- Remove tokens no longer in use.
2 -- only clean after code has expired
5 SELECT t.code_id
, t.is_token
, t.is_revoked
, t.expires
, t.refresh_expires
FROM token t
6 WHERE t.created
< (now() - $
(codeLifespanSeconds
)::text::interval)
8 DELETE FROM token WHERE code_id
IN (
9 SELECT code_id
FROM cleanable_codes
11 NOT is_token
-- profile-only redemptions
17 -- expired and unrefreshable
18 refresh_expires
IS NULL
20 -- expired and refresh expired
21 (refresh_expires
IS NOT NULL AND refresh_expires
< now())