UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZ3P36MZ2YX3icExn/soGeQ352G0KL78G5V+1sqtbEU='
WHERE
key_id = '0f25511c890c47ba582b486c6cd62b17309800b92a1fa57bfb2b76eda6ebe786'
AND (
token = 'ZZ3P36MZ2YX3icExn/soGeQ352G0KL78G5V+1sqtbEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)