UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpGKvmTYQb/UEHwrZq0VGkCLfac6b1kigmOFt3Moeic='
WHERE
key_id = 'd7be5ab8ef93702a57107f0c54f490de65f2904b44f98ff169123efbf1450382'
AND (
token = 'XpGKvmTYQb/UEHwrZq0VGkCLfac6b1kigmOFt3Moeic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)