UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XT68icmcDY4G+pA5rQ41dH5RKDhKLZKUWG0fvMCaUgs='
WHERE
key_id = 'f3fcdfc0ab3191d4823f4cb15ceb3718db9f97e27dbfe688a786f4716820628f'
AND (
token = 'XT68icmcDY4G+pA5rQ41dH5RKDhKLZKUWG0fvMCaUgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)