UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3nKtcZW5kWzGfWSF5g+zMc8DScxGWws/jox6A/QM1DM='
WHERE
key_id = 'b587c7c6828c89b0c0df5e4b3a7f89c04232c776b7ee1371c91ae1a6c9997616'
AND (
token = '3nKtcZW5kWzGfWSF5g+zMc8DScxGWws/jox6A/QM1DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)