UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M1ItE9lFPrh3j/rCCDCAX82QSzMsIUlWXOuJKTrSK4o='
WHERE
key_id = 'b01d17adf532b032b8e6e27d8cd67648cf7126035a36b09ffb4470b22ec84f30'
AND (
token = 'M1ItE9lFPrh3j/rCCDCAX82QSzMsIUlWXOuJKTrSK4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)