UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xG2xbjzTxE0T+xu3WICDm967sPjpF/onm1zgolagCMA='
WHERE
key_id = '88339a14b33fe83c34e70a5fff478e716448970bee860f626a1dcf8477913935'
AND (
token = 'xG2xbjzTxE0T+xu3WICDm967sPjpF/onm1zgolagCMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)