UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mWDhCjNvf50UXqqnqw0xWqP5y8XxmbP7/Gl3WfNsog='
WHERE
key_id = 'd66bb6c773137651c9e15cc10b34c6c10bc1db2f5520436171b26205c368109d'
AND (
token = '8mWDhCjNvf50UXqqnqw0xWqP5y8XxmbP7/Gl3WfNsog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)