UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9kvC9hOXG3G9crCm6z6uRhEz1PM1W9c+fOuSU8qvP9U='
WHERE
key_id = '1f4db7fd3e5554618bd00ca01004ddfe371dac70c2b52a1d9757119fe3059b73'
AND (
token = '9kvC9hOXG3G9crCm6z6uRhEz1PM1W9c+fOuSU8qvP9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)