UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JZ/WWfp51xGrxKSvMZvqqm41R/RMLg+aWVItZvzFo8='
WHERE
key_id = '4823cdd1a8b20b7beb412aa5becbcc4613a4c5a690117f1f13652b7fffafc981'
AND (
token = '8JZ/WWfp51xGrxKSvMZvqqm41R/RMLg+aWVItZvzFo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)