UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ppICwwLMD8Oy+731Zs5fc2fUx23ajB6gSfft4KID+iU='
WHERE
key_id = '196d049107de94216c84e9b8ae588ecbcb1240b2eb41c038b4a35966f1b10717'
AND (
token = 'ppICwwLMD8Oy+731Zs5fc2fUx23ajB6gSfft4KID+iU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)