UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EI4s1vDGLUqXNuF0gvnzc2W5yN3dSsbaWOjWLdax7uM='
WHERE
key_id = '3269bdd42a24bbf9f36c40e2703e386c8d75dfc7f9082f1877ea98b3fba76815'
AND (
token = 'EI4s1vDGLUqXNuF0gvnzc2W5yN3dSsbaWOjWLdax7uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)