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