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