UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIgmWGmX937njEXUn+7GRFFGU04tv/32Scz6qVmPnaU='
WHERE
key_id = '651bd2e246b4de38d854c91036b6041c2bb20cb1a87e06bd940e8aafb534cf07'
AND (
token = 'ZIgmWGmX937njEXUn+7GRFFGU04tv/32Scz6qVmPnaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)