UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rLlIkbpJmjVhcvKn0G+Z4iHA+E645Jnnzf1zCf4cAug='
WHERE
key_id = 'fe9e6a4a969d9ebafcb5979d62ded723e2c14868875bdb4825cd9fd57e16cf7f'
AND (
token = 'rLlIkbpJmjVhcvKn0G+Z4iHA+E645Jnnzf1zCf4cAug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)