UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wle33jhhoeMkVxE5NYVZjUr1AqTJOsU3VANVFCn5abg='
WHERE
key_id = 'afb04376c912457faab25fb04539446175b675d29897c6a37b1acfbe42a04fe6'
AND (
token = 'wle33jhhoeMkVxE5NYVZjUr1AqTJOsU3VANVFCn5abg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)