UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JM2DrKQnC6AqwXIGUqhvA5L6AiO7ybnhVZvAtAnydtw='
WHERE
key_id = '2f0fafdcacab2dd97ca44eaee4087ce7af67a38af74c3f2d78aff846a9e7061e'
AND (
token = 'JM2DrKQnC6AqwXIGUqhvA5L6AiO7ybnhVZvAtAnydtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)