UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0/EcgOr8whigkpda3LrXfV+OCZ3ouR+sFM2O6NLMZzc='
WHERE
key_id = '9b831de00b9dab5c44ec2c22761774b16fc94c91f0d5e04d410bb55caf1eff1a'
AND (
token = '0/EcgOr8whigkpda3LrXfV+OCZ3ouR+sFM2O6NLMZzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)