UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Ec20KNBEnnJIC5vdiAVV0mZHkH5gPMkESUQaUFb6PA='
WHERE
key_id = '99dad8e6c18dcd7347ab85db9be850a3822faff4e7d2f95f971551d38d246a11'
AND (
token = '2Ec20KNBEnnJIC5vdiAVV0mZHkH5gPMkESUQaUFb6PA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)