You cannot join two tables in update statement. You can use subqueries instead. Try the ff. codes:
UPDATE CustomerBankInfo
SET Money = (money - @ordervalue)
WHERE CustomerBankInfo.CustomerID = (SELECT CustomerID
FROM Customer
WHERE Firstname = @custFName
AND LastName = @custName)