UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVCUuY2DhROYZccYo7XZXe0Bf9XnpnRlzerAp0DE/oU='
WHERE
key_id = '8f503c3f81830140e28dadc1b5cb4b750522677b891abd5b33064f95a89f10aa'
AND (
token = 'XVCUuY2DhROYZccYo7XZXe0Bf9XnpnRlzerAp0DE/oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)