UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TSnPF53SU0l5+qF7UTffxInSk/6cvFvMxZhSsoIiq5A='
WHERE
key_id = 'faed3e85d333c37356c39912b2ff90730ef8dd93e40dc30e6f2a24f171e462ae'
AND (
token = 'TSnPF53SU0l5+qF7UTffxInSk/6cvFvMxZhSsoIiq5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)