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