UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ujhle+Ox98J8ke0E0C39YUKPhf3wwKunaOHOztGrvg8='
WHERE
key_id = '7d0d41bb93a1ca355c334d391d2ae54d1868ffd052275e5fbccf040ea049c1b1'
AND (
token = 'Ujhle+Ox98J8ke0E0C39YUKPhf3wwKunaOHOztGrvg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)