UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+nSgr34XntFcEDaV3BC9wm3Ur0Wq33yM4waZ1hMyfpk='
WHERE
key_id = '42a272c25d7bd371553477911a1a6047a742a35bfa5539b965361a84bad4fcba'
AND (
token = '+nSgr34XntFcEDaV3BC9wm3Ur0Wq33yM4waZ1hMyfpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)