123

$cardsToChange = ['YE5017691','CY8561741'];
foreach($cardsToChange as $currentCardToChange)
    {
        $newValForCard = substr($currentCardToChange, 0, -1);
        $query = "UPDATE `sands_card_client` SET CARD_NUMBER = '{$newValForCard}' WHERE CARD_NUMBER = '{$currentCardToChange}';";
        $DB->Query($query);
    }