UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zK1RP2WuRjeTXDR3Pxh2s7BTvpWyyt7AMjV7jTOBEf8='
WHERE
key_id = '6b6a144acfdca7b75cca5fccac7d08644cd6db247fa075d1022c10d8e5461b77'
AND (
token = 'zK1RP2WuRjeTXDR3Pxh2s7BTvpWyyt7AMjV7jTOBEf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)