UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vT9qRXO9SfwfylMOV2WyXQy1WONuXYH8hDqmrwDKDTA='
WHERE
key_id = 'a941d4f236544371df64ecba7e9daf5a905c992c887783215d3ecbcbcd0ea1b4'
AND (
token = 'vT9qRXO9SfwfylMOV2WyXQy1WONuXYH8hDqmrwDKDTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)