UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xz9EshzLm1NVzv5FNCEdDiq3dpr7TI/WQh8KP1cI/oU='
WHERE
key_id = '94a690cfaaf8ade0fb92b0183ff88b854d80441d92004330e0eb921b192cfb29'
AND (
token = 'Xz9EshzLm1NVzv5FNCEdDiq3dpr7TI/WQh8KP1cI/oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)