UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Eco4EheSEi7zwhYYgXJGzOPL8uJPg3P7sCCnAutTjBo='
WHERE
key_id = 'a8484f53db7e8d3fd3e6de0a3ced13c8cc4d0209c2e7712cc895cb7429fc1f24'
AND (
token = 'Eco4EheSEi7zwhYYgXJGzOPL8uJPg3P7sCCnAutTjBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)