UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFMwQ84cXn2u7TyAfVDuqKAL/RJnKOyF2Hfd2m1sZqc='
WHERE
key_id = 'a4b2e1977066a1dde581110051a5205b2689288ce60c3e590a0d526d202380ea'
AND (
token = 'XFMwQ84cXn2u7TyAfVDuqKAL/RJnKOyF2Hfd2m1sZqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)