Full Table

-key-markcolorprice
5PeugeotRed1550
14PeugeotGreen1200
22PeugeotBlue1400
31CitroenRed2000
45CitroenYellow1800
52CitroenBrown1400
67NissanBrown1700
71NissanGreen1750
89NissanRed1500

Update (price > 1500 => price / 10)

-key-markcolorprice
5PeugeotRed155
14PeugeotGreen1200
22PeugeotBlue1400
31CitroenRed200
45CitroenYellow180
52CitroenBrown1400
67NissanBrown170
71NissanGreen175
89NissanRed1500
$table->update(
    ConditionBuilder::createAnd()
        ->greaterThan('price', 1500)
    , function ($row) {
    $row['price'] /= 10;
    return $row;
}
);

Delete (price < 180 or color = "brown")

-key-markcolorprice
14PeugeotGreen1200
22PeugeotBlue1400
31CitroenRed200
45CitroenYellow180
89NissanRed1500
$table->delete(
    ConditionBuilder::createOr()
        ->lowerThan('price', 180)
        ->equalTo('color', 'brown', false)
);