UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '00btbfE+xlpyrYlsK7KzYZc6POLDosul94BQqyCm1aE='
WHERE
key_id = '1a7733f7d24c6cb6647437a85d58e6c57d89a24620736997b55728b6586ef61f'
AND (
token = '00btbfE+xlpyrYlsK7KzYZc6POLDosul94BQqyCm1aE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)