UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXVSBTDw4jfV2sEVW5teBBqcuSTZ78fS38BOV7XmtPE='
WHERE
key_id = 'c729e284cff1870efb8b72c52ef9bd7a9a006d34bc21129b74a9d2c68e5af07e'
AND (
token = 'TXVSBTDw4jfV2sEVW5teBBqcuSTZ78fS38BOV7XmtPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)