<cfquery name="qUpdate" datasource="xxx">
	UPDATE
		[account]
	SET
		balance =
		(
			CASE
				WHEN
					((balance - 10.00) < 0)
				THEN
					0
				ELSE
					(balance - 10.00)
			END
		)
	WHERE
		id = 1
</cfquery>