UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h6u75o475gC35RluzMp4OU2KB08Ty8NIzZIOCSMxnIw='
WHERE
key_id = '379562720088680f1dfe5176c40c071d94b928a8e55b1fc1fad01e36cd12a381'
AND (
token = 'h6u75o475gC35RluzMp4OU2KB08Ty8NIzZIOCSMxnIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)