UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPTrdPB12I6TKL/zsWOTEi9Q4wcJ08rNZYc1NfkTOPk='
WHERE
key_id = 'df8a9133f89c8a607eda8609cd5308728e488aa57c53c02234510ed2187f1801'
AND (
token = 'lPTrdPB12I6TKL/zsWOTEi9Q4wcJ08rNZYc1NfkTOPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)